﻿CREATE VIEW dbo.BemanningFull
AS
SELECT     dbo.Funktion.Beskrivning, dbo.Funktion.PublikBeskrivning, dbo.PersonFull.PersonPersonnummer, dbo.PersonFull.PersonFornamn, dbo.PersonFull.PersonEfternamn, 
                      dbo.PersonFull.PersonTelNr, dbo.PersonFull.PersonMobTelNr, dbo.PersonFull.PersonEpost, dbo.PersonFull.PersonAdress, dbo.PersonFull.PersonPostNr, 
                      dbo.PersonFull.PersonPostOrt, dbo.PersonFull.PersonFritext, dbo.PersonFull.PersonStatus, dbo.PersonFull.PersonStatusID, dbo.PersonFull.PersonTyp, x.TackatJa, 
                      x.ValdistriktId, x.GruppId, dbo.PersonFull.PersonId, dbo.PersonFull.ValId
FROM         (SELECT     Id, ValId, Skapad, SkapadAv, Andrad, AndradAv, PersonId, FunktionId, NULL AS GruppId, ValdistriktId, TackatJa
                       FROM          dbo.BemanningValdistrikt
                       UNION ALL
                       SELECT     Id, ValId, Skapad, SkapadAv, Andrad, AndradAv, PersonId, FunktionId, GruppId, NULL AS ValdistriktId, TackatJa
                       FROM         dbo.BemanningGrupp) AS x LEFT OUTER JOIN
                      dbo.PersonFull ON dbo.PersonFull.ValId = x.ValId AND dbo.PersonFull.PersonId = x.PersonId LEFT OUTER JOIN
                      dbo.Funktion ON x.ValId = dbo.Funktion.ValId AND dbo.Funktion.Id = x.FunktionId
GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 1, @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'BemanningFull';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[35] 4[30] 2[16] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "x"
            Begin Extent = 
               Top = 20
               Left = 654
               Bottom = 274
               Right = 805
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "PersonFull"
            Begin Extent = 
               Top = 47
               Left = 59
               Bottom = 306
               Right = 267
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Funktion"
            Begin Extent = 
               Top = 50
               Left = 1286
               Bottom = 396
               Right = 1447
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 18
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'VIEW', @level1name = N'BemanningFull';



